﻿CREATE TABLE [dbo].[ClientAddress] (
    [Id_ClientAddress] INT           IDENTITY (1, 1) NOT NULL,
    [Id_Client]        INT           NOT NULL,
    [Id_Address_Type]  INT           NOT NULL,
    [Street]           VARCHAR (100) COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Number]           VARCHAR (10)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Complement]       VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [District]         VARCHAR (50)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [ZipCode]          VARCHAR (15)  COLLATE SQL_Latin1_General_CP850_CI_AI NULL,
    [Id_City]          INT           NULL
);

